Modifying Query Summary Definitions

With the Modify Query Summary Definition screen, you can group together data records to create and modify summaries that appear in query output.

To create summary groups for a query, type G in the Opt field for that query on the Work with Queries screen (STRFW > 41 > 1) as shown in Creating and Running Queries.

The screen also appears in the process of adding or modifying queries if the Summaries field on the Exit Query Definition screen is set to Y (as shown in Adding and Modifying Queries).

​                       ​ Modify Query Summary Definitions​      ​ User Defined​                                                                                       ​ Query .​ TESTJZ    ​ ​ Test for Documentation                            ​                                                                                                                          ​ Summary Report 1​                                                                                                                  ​ Title  . . . . . . . . .​ ​ Count of Objects Allowed/Rejected by Library ​         ​ Group by . . . . . . . .​ ​ 00OBJ     ​ Object                                  ​                             ​ 00LIB     ​ Object library                          ​                             ​ 00RTCD    ​ Allow (1=Yes)                           ​   ​ Sum field or *COUNT  . .​ ​ *COUNT    ​                                            ​ Report if sum is . . . .​ ​  ​         ​ >=Greater than, <=Less then​                  ​ Than . . . . . . . . .​ ​   0​       ​ Number​                                       ​ Specified in units of.​ ​  ​         ​ K=Kilo, M=Mega, G=Giga​                     ​ Sort by the sum  . . . .​ ​  ​         ​ A=Asc, D=Dsc​                               ​ Code to add description.​ ​  22​       ​ F4 to select based on the Group By fields​                                                                                                                                                                                                                                                                                                                                                                                                             ​ More...​  ​ F3=Exit   ​ F4=Prompt ​ ​ F12=Cancel                             ​                  ​                                                                                                                                                                  ​

The screen includes fields for creating up to three summaries. These appear on successive pages, which you can reach by pressing the Page Down key.

The fields for each are:

Query

A read-only field showing the name and text description of the query.

Title

A free-form text title for the summary.

Group by

How to group items in the output.

A group of three subfields set the fields by which items in the report are grouped. You can set this via the Code to add description field or by pressing the F4 key in each field to select the fields from a list.

Sum field or *COUNT

The field from the record for which the sum of values since the last summary is shown, or *COUNT to show the number of records.

Report if the sum is

Whether the summary appears if the sum is greater than the value in the Than field or when it is less. Possible values are:

• > : Greater than
• < : Less than

Than

The value to which the sum is compared.

Specified in units of

Units to which the values are rounded and displayed:

• K: Kilo
• M: Mega
• G: Giga

Sort by the sum

Possible values are:

• A: Ascending
• D: Descending

Code to add description

A code specifying groups of items to place in the three subfields of the Group by field. Press the F4 key to see a list of the field sets.